﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_ABSENCES_IN')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_ABSENCES_IN
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_USER_ABSENCES_IN] 
(
    @TUA_USER_ID Integer,
    @TUA_START_DATE Datetime,
    @TUA_END_DATE Datetime,
    @TUA_WEEKEND Integer 
)
AS
	INSERT INTO TB_USER_ABSENCES
	(TUA_USER_ID,TUA_START_DATE,TUA_END_DATE,TUA_WEEKEND)
	values
	(@TUA_USER_ID,@TUA_START_DATE,@TUA_END_DATE,@TUA_WEEKEND)


GO

GRANT EXEC ON dbo.PRC_TB_USER_ABSENCES_IN TO PUBLIC

GO

